package com.s3.khospitalds.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.s3.khospitalds.entity.Staffintroduction;
import com.s3.khospitalds.entity.Userlogin;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author hlq
 * @version 1.0
 * @Description
 * @date 2025/2/20 10:22
 */
@Mapper
@Repository
public interface EmployeeintroductionMapper extends BaseMapper<Staffintroduction> {

    //查询全部医生介绍
    @Select("select * from staffintroduction where profession like '%医生%'")
    public List<Staffintroduction> IntroduceAll(String profession);
    //查询全部护士介绍
    @Select("select * from staffintroduction where profession like '%护士%'")
    public List<Staffintroduction> NurseAll(String profession);
}
